##ENSURE SPREADSHEET IS FILTERED FIRST RUN_DATE (oldest to newest) then by DATETIME (oldest to newest)

Clean data: Look at sample concentrations for each day. Select which value from different run (out of the series of duplicate and dilution runs)

350

Raw Visualize

Create good_id vector for site 350

# Points to background correct
good_id_mc3_bg<-c(68:75, 925:932, 236:238, 1093:1095, 265:267, 1122:1123, 1979, 1980, 1982, 280:283, 1137:1140, 1994:1997, 665:668, 1522:1527, 145:149, 1002:1006, 694, 695, 697, 795, 1551, 1552, 1554, 163, 164, 166, 167, 1020, 1021, 1022, 1877, 1878, 2408, 2409, 2411 )#350

# 85:91, 899:906, 235:237, 1049:1051, 265:268, 1079:1080, 1893, 1894, 1896, 280:283, 1908:1911, 667:670,672, 149:153, 963:967, 706:708, 1520:1522, 2334:2336, 167, 168, 170, 171, 981:984, 1795, 1796

good_id_mc3_fall<-c(291:293, 295, 297, 299, 302, 305, 307, 933:935, 1061:1063, 1065, 351, 352, 354, 356, 358, 360, 362, 429, 366, 368, 370, 1096:1107, 373, 375:379, 381, 382, 390, 391, 1126, 1128, 1129, 1983:1990, 392, 394, 395, 397, 399, 401:403, 1141, 1146, 1998:2003, 2058, 2060, 2061, 2063, 2064, 672, 674:681, 1641:1650, 627:635, 438, 424, 625, 626, 1007:1014, 1016:1019, 715, 718:724, 638:641, 663, 664, 810, 811, 812, 813, 814, 1028, 1047, 1048:1056, 1880:1881, 1885, 1904:1913, 1652:1665, 2509:2523, 2538) #350

# 301:309, 907:909, 1014:1016, 320, 351:360, 430, 1052:1063, 373, 375:379, 381:384, 1085:1086, 1898:1904, 385:387, 389:393, 1912:1917, 1950:1954, 674, 676:683, 627:632, 634:636, 972:975, 977:980, 716, 718, 719, 721, 723, 724, 638:643, 988:997, 1797, 1799:1811

450

Raw Visualize

Create good_id vector for site 450

## # A tibble: 1 x 1
##       n
##   <int>
## 1    11

350

Visualize Selected Data

450

Visualize Selected Data

Summarize to get mean BG conc per day

## # A tibble: 16 x 5
## # Groups:   date [8]
##    date       site      Cl     NO3    PO4
##    <date>     <chr>  <dbl>   <dbl>  <dbl>
##  1 2018-06-26 350   0.0873 0.0697  NA    
##  2 2018-06-26 450   0.112  0.213   NA    
##  3 2018-06-28 350   0.100  0.211   NA    
##  4 2018-06-28 450   0.0975 0.005   NA    
##  5 2018-06-30 350   0.118  0.100    0.005
##  6 2018-06-30 450   0.0956 0.0334   0.005
##  7 2018-07-02 350   0.121  0.005    0.005
##  8 2018-07-02 450   0.168  0.0438   0.005
##  9 2018-07-17 350   0.165  0.00737 NA    
## 10 2018-07-17 450   0.0830 0.0649  NA    
## 11 2018-07-19 350   0.239  0.0551  NA    
## 12 2018-07-19 450   0.211  0.0663  NA    
## 13 2018-07-21 350   0.202  0.0634   0.005
## 14 2018-07-21 450   0.791  0.108    0.005
## 15 2018-07-23 350   0.320  0.0602   0.005
## 16 2018-07-23 450   0.190  0.214    0.320

Background correct falling limb sample concentrations.

Visually inspect background corrected falling limb sample concentrations for each day.

Graph site 350

Graph Site 450